Creating Interviewee Activity - Page 4 of the dashboard 24

Creating Interviewee- Page 4 of the dashboard

Duplicate the KPI Overview page and delete everything except the Interviewee NPS and Interviewee Score KPI cards and rename the page to Interviewee Activity. Then change the name in the text box as Interviewee Activity Dashboard, and move the colaberry logo to top left side and align it as shown in the screenshot below.

Creating Scattered Plot:

Step 1: In Fields

Select the scattered plot icon from the visualization panel.
Select Interviewer from Interviewer Dim table to Details
Select IntervieweeScore from the Measure table to X-Axis
Select Interviewee NPS from Measure table to Y-Axis
Select Interviewee from Interviewee Dim table to Size
Select Year Month from Date table to Play Axis

Step 2: In Format Tool.

X axis
- Start Auto, End 2
- Text size 9
- Font Family - Segoe UI
- Title text size - 12
- Title OFF
- Everything else remains the same.
Y axis
- Start -120, End 120
- Title ON
- Everything else same as above (X axis)
Data Color:
- Format by - Field value
- Based on field - ScatterColorInterviewee from the Measure table.
Category ON
Title ON and renamed to "Interviewee NPS & Score by Interviewer."
Background ON
- Color - White, and Transparency - 0
Tooltip ON
Visual header ON

Step 3: In Analytics

X-Axis Constant Line 1 click + add
- Value 0.8
- Transparency 50
- Line style - Dashed
- Position - In front
Y-Axis Constant Line 1 click + add
- Value 55
- Everything else same as above (X-Axis)

Step 4: Adding the Rolling 12Months

Select Filters panel.
Drag and drop Rolloing12Month from the Date table to the area that says "Add data fields here" as shown in the screenshot.
On the Filter type, select Basic filtering and select 1

after that go to filter pane click on expand button next to the Interviewer, select basic filtering, click on select all and then uncheck (Blank) as shown in the screenshot to avoid blanks in the report.

When you are done putting all these together, you will have something like this.

Scatter plot with play button:

https://www.youtube.com/watch?v=64-eK-tdTPc